package com.lzs.DAO;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.lzs.PO.Certificate;
import com.lzs.PO.CertificateExcel;
import com.lzs.PO.Member;

public interface CertificateDAO {

	public List<Certificate> findCertificatelist(@Param("rural_id")String rural_id, @Param("keyword")String keyword);

	public List<Certificate> findCertificatePagelist(@Param("rural_id")String rural_id, @Param("keyword")String keyword, 
			                                                                       @Param("startIndex")int startIndex, @Param("pageSize")Integer pageSize);

	public long countCertificateByDisease(@Param("disease_name")String disease_name,@Param("rural_id") String rural_id);

	public Member findCertificateWithMemberByRuralId(@Param("rural_id")String rural_id);

	public void addCertificate(Map<String, Object> map);

	public Certificate findCertificateWithMemberByCertificateIdAndRuralId(@Param("certificate_id")String certificate_id, @Param("rural_id")String rural_id);

	public void updateCertificate(Map<String, Object> map);

	public void deleteCertificate(@Param("certificate_id")String certificate_id);

	public List<Certificate> findCertificatelist4All(@Param("keyword")String keyword);

	public List<Certificate> findCertificatePagelist4All(@Param("keyword")String keyword, @Param("startIndex")int startIndex, @Param("pageSize")Integer pageSize);

	public List<CertificateExcel> findCertificate4InputExcel(@Param("keyword")String keyword);

	public long countCertificateByRuralId(@Param("rural_id")String rural_id);

	public Certificate findCertificateByDiseaseAndRuralId(@Param("disease_name")String disease_name, @Param("rural_id")String rural_id);

}
